ItemPriceMaintenance

Entity Definition

Logical Name : ItemPriceMaintenance
Physical Name : MA_PRC_ITM

A type of ItemMaintenanceEvent that updates the current retail price of an Item.

Data Definition

Attribute Description Physical Name Domain Data Type Foreign Key Table
EventID (FK)(PK) A unique, automatically assigned identifier for the Event ID_EV Identity integer
TypeCode A code to denote how the permanent price is actioned, ie global or individual ITEM amendment. TY_PRC_MNT Code2 char(2)

Relationships

Parent Entity Verb Phrase Child Entity
ItemMaintenanceEvent can be a ItemPriceMaintenance
ItemPriceMaintenance can be a PermanentPriceChange
ItemPriceMaintenance can be a TemporaryPriceChange

Logical Views containing ItemPriceMaintenance

Logical View
Logical 01300 - Item Price Maintenance View
Logical 06700 - Event Scheduler View